UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+i5wpAEHRZ2fwW9NvKO6K6wTSD5SRAdzRZAUcrioDc='
WHERE
key_id = 'b7bb9f41cac07b6d3c49269de63d2ee9f8c08d4d009a5b7f7e24c9f040cd04e0'
AND (
token = 'N+i5wpAEHRZ2fwW9NvKO6K6wTSD5SRAdzRZAUcrioDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)