UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGSRQHRABbhz5wSMU1EUwb+/0RabYBkMKQXJQZZtVYs='
WHERE
key_id = 'a257e03c376579d2972a54a8382a548e002dfc82c29d9cb96784b41411115ccf'
AND (
token = 'zGSRQHRABbhz5wSMU1EUwb+/0RabYBkMKQXJQZZtVYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)