UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jZnGVc4DQqri/pA1MiryfW1POgQV13+9ta9eL+G3u2E='
WHERE
key_id = '5758011543d48f174158416e08b28fa54427a0f4cca43d541605625cdf88c95a'
AND (
token = 'jZnGVc4DQqri/pA1MiryfW1POgQV13+9ta9eL+G3u2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)