UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8NSMZarVmxx4VdKh1P5dyXnq92vEspWAnR4H8ZnM9Q='
WHERE
key_id = '6e31d1fe063ab2f767aa4ae516ceb6346646963b60e3ef81e86582a85a4a3ac4'
AND (
token = 'p8NSMZarVmxx4VdKh1P5dyXnq92vEspWAnR4H8ZnM9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)