UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zffnsPJ5auvJrk3g20A+R8AtADm5HOWUSAGWTwSgsk='
WHERE
key_id = '3d862ae399d2364bfba63993d2563e18384976942cb23dc62dc5923d3a6a993f'
AND (
token = '/zffnsPJ5auvJrk3g20A+R8AtADm5HOWUSAGWTwSgsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)