UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCvkxZeG33M7Tu/UJRl8m0lV7fSQ5nXwmn8CDnn1IRU='
WHERE
key_id = '7e8eae8f2c1defb894db91f47e2997935fb174d7b181eb146ec5336890c10160'
AND (
token = 'YCvkxZeG33M7Tu/UJRl8m0lV7fSQ5nXwmn8CDnn1IRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)