UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXKSDEdh0f2mMkH8Nmt13ou/e1f7DplENPaKaR3+hJw='
WHERE
key_id = 'e486ec1486d53be0d376f79999a530f44f370d1dab046e68df9cb29a6d70c76a'
AND (
token = 'kXKSDEdh0f2mMkH8Nmt13ou/e1f7DplENPaKaR3+hJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)