UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0TRQebtLP6emV3kyvJpv6i9VnplpyY0/yPW/dqzAP4='
WHERE
key_id = '7b711e59bf3e4d1f2334e0904cab747516054f7ab785f9ccace4437f86c3aaee'
AND (
token = 'I0TRQebtLP6emV3kyvJpv6i9VnplpyY0/yPW/dqzAP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)