UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPHZ4tA6f+iodjLy9yUskaQ4kdlrDhv7mmjhMqrll/8='
WHERE
key_id = 'c45d6357891f5dba98647a9f247d6ae373e90f73f79a2f7f56445daed19e4511'
AND (
token = 'LPHZ4tA6f+iodjLy9yUskaQ4kdlrDhv7mmjhMqrll/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)