UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XtDxCuCz1ADx9IYFi38PQLsGSoUQvaAvB0M6xnVT/o='
WHERE
key_id = '7e7058ac8e966718ea59419c585fdcbe3289151f4fc2ebcd602a654d63862039'
AND (
token = '5XtDxCuCz1ADx9IYFi38PQLsGSoUQvaAvB0M6xnVT/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)