UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cgNG2HMhxEAu9MrgkA3l8qETGbRKS8RfnE5yJG0y6LI='
WHERE
key_id = '19e6a87682fb7f511256252c91abb2ac25357b439e3bc5b5d872ba62615c3988'
AND (
token = 'cgNG2HMhxEAu9MrgkA3l8qETGbRKS8RfnE5yJG0y6LI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)