UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D57TRS5gZL+6lQ9QUnsngauWzMqoB0iibhHjpHs/AVE='
WHERE
key_id = 'f47f066d54cb9ec6447e1275de001930f350eeae62a52993e18b704953effcbb'
AND (
token = 'D57TRS5gZL+6lQ9QUnsngauWzMqoB0iibhHjpHs/AVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)