UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBGHyBXtAxtIZRNAcQ6fPb5qkaDTuMGwx78MFL0V+Qc='
WHERE
key_id = '9c41aecdce4ff73a001e3893f2ce372d5a41da3d91a964d8bd2e702d63b8aab7'
AND (
token = 'KBGHyBXtAxtIZRNAcQ6fPb5qkaDTuMGwx78MFL0V+Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)