UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hoxNpGWs3i3uPE6OafJXmz+UuGdfm8hzh9tLC7YsUU='
WHERE
key_id = '127d4cedc2c798de02c63b8947895d8247bd2c1dbf504dd6d6a847338afa9289'
AND (
token = '1hoxNpGWs3i3uPE6OafJXmz+UuGdfm8hzh9tLC7YsUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)