UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EA4qsvG2eMhEWqRNnAJoQDlEPZNaBFkk0+ikoSu2Z5w='
WHERE
key_id = 'ed2d2ac72f6385c0d2ae788f146d14352604ce181414afb7d1defa7d1fe3506a'
AND (
token = 'EA4qsvG2eMhEWqRNnAJoQDlEPZNaBFkk0+ikoSu2Z5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)