UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vV3f5NQrvweVHhsLPtM4BhzwviX0NmPV9I/uW9U4vmE='
WHERE
key_id = '6473b0e903801e4e28a46c44adc8d1f77f9cee3c7c22559830da59e2db4b303e'
AND (
token = 'vV3f5NQrvweVHhsLPtM4BhzwviX0NmPV9I/uW9U4vmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)