UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2oaCBBIswI3ktYcSDRMYTDRVJn9KwJbJv6s10BcB8zM='
WHERE
key_id = 'cba172e9e39d65b34aeabf711e4b1fccc3c56ddfede13a7727b244ff74de2d4b'
AND (
token = '2oaCBBIswI3ktYcSDRMYTDRVJn9KwJbJv6s10BcB8zM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)