UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+fx/zN05jFAOKdCY0YQIwYAT6WXfAVYscRHPslGGa4E='
WHERE
key_id = 'b1cae8650a2d5b1aca964bcb96d607e0e6207b2cd7af707493026bf26e3a0000'
AND (
token = '+fx/zN05jFAOKdCY0YQIwYAT6WXfAVYscRHPslGGa4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)