UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHgwls0J0y5tVTOS7JvoymojEQyKGoaXWi1McuLiD4E='
WHERE
key_id = '2a81699a5ed68944d8600062ee3f7df1f05d23b416d1e829e7a7243b9d480176'
AND (
token = 'HHgwls0J0y5tVTOS7JvoymojEQyKGoaXWi1McuLiD4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)