UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vl8xuH+C+7Og5cJkoMsW7enV+nxOAof5cMhNzzHge1Y='
WHERE
key_id = 'e01ad807f746729c38916b10fc98fafd22ad46de66862f57273ec4371c949c6a'
AND (
token = 'vl8xuH+C+7Og5cJkoMsW7enV+nxOAof5cMhNzzHge1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)