UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oxoJMrh6lIFbgG9iUj+K9bwSyQuWDm1zubggsCzuGY0='
WHERE
key_id = 'b67b4ec88c7d32a2fa29c179a41bbf8610ef7c9287f12a659983e8c1e29e59cc'
AND (
token = 'oxoJMrh6lIFbgG9iUj+K9bwSyQuWDm1zubggsCzuGY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)