UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6g1pjZLPS9GOOfzNiqDJhVQInkji9skhgph0uZ02Q/A='
WHERE
key_id = 'a8182cc781fa55b85210a9210ef50481a3a7287048fc06f3ed3ea6ea3144f189'
AND (
token = '6g1pjZLPS9GOOfzNiqDJhVQInkji9skhgph0uZ02Q/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)