UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DW/SFSlY0caWUs0/F7Fe7ZsJvYZrlpZHgQuKyc0vWCs='
WHERE
key_id = 'd00af12ea6f70149fa1e30df5c1bb3be1c953009c5fcbfd1ea3ca4d3eacc28de'
AND (
token = 'DW/SFSlY0caWUs0/F7Fe7ZsJvYZrlpZHgQuKyc0vWCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)