UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BAHc7NwTQ9LcKFalwWdjrtZ5nQOz7yebevTm7Yy271M='
WHERE
key_id = '7093b2f52ad57f2cfaf58ec4d98fb5bc177c5366e895ce5c8b1a3c0584b3d992'
AND (
token = 'BAHc7NwTQ9LcKFalwWdjrtZ5nQOz7yebevTm7Yy271M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)