UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8K7tpCftbfSAGCyo/GZ2ZIo9sid5EnWbMTO/cxd5G4s='
WHERE
key_id = 'ad612c3cf881654c8e4ee14bebc17a504836ac16fe48fa530249544a17123550'
AND (
token = '8K7tpCftbfSAGCyo/GZ2ZIo9sid5EnWbMTO/cxd5G4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)