UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N6NHthz5oTb8egjwjoRch5ssHGXGRqHWIQUwDjICGiU='
WHERE
key_id = '31f4b2889c53c39d55da1d35cb43958d112dcde8c4041117f01ff887eb656d6a'
AND (
token = 'N6NHthz5oTb8egjwjoRch5ssHGXGRqHWIQUwDjICGiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)