UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfa/1PgK72kuvjG0eVw5MmLfNr4zO155LyE0iXGQRJE='
WHERE
key_id = '0665ff4317e2ee8d4aca31390d6070df7885c5a89a6c84ef8330999c6f0505d6'
AND (
token = 'pfa/1PgK72kuvjG0eVw5MmLfNr4zO155LyE0iXGQRJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)