UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzcwS5qrtPIHI1GDvj6wmjPuVr03YnMu/qw27iFHpPo='
WHERE
key_id = '8ef740af70b5e77c68c1c0855fcf8689cec6d0fc536d2bd06e7e13aaffc59bce'
AND (
token = 'KzcwS5qrtPIHI1GDvj6wmjPuVr03YnMu/qw27iFHpPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)