UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vportQQsJkS/AL6d+xAhLAQn+J25qV44q+svJEnhieI='
WHERE
key_id = '5942cbd0169bd8bc08359321557b2d08b4b3dbd1a23e83e10f6d4df770f4246d'
AND (
token = 'vportQQsJkS/AL6d+xAhLAQn+J25qV44q+svJEnhieI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)