UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1cTKXPwYZAY+k+gEaFTnMKhd2LZeN1aj4qRLSGsIG0='
WHERE
key_id = '9b5eaccc46d1fb9d013c8a322b0f20a5bd5ecc29432d7a3bad9733ee07d46ade'
AND (
token = 'W1cTKXPwYZAY+k+gEaFTnMKhd2LZeN1aj4qRLSGsIG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)