UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gtyzh/bzXD49jPsjURlIoxncC0GHkouQU74zMFbCmyk='
WHERE
key_id = 'a0cfc003b0bdbb8f86d0c25118f8dbf6c3d153315e685babfd9a99bf8bb9c097'
AND (
token = 'Gtyzh/bzXD49jPsjURlIoxncC0GHkouQU74zMFbCmyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)