UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpg//bDOTflI2JDgNq4t0244fxZFOKibHUyFsOoU8Dg='
WHERE
key_id = '05c0ce0996ce6b99c54d17199420da97e7e708b2f079ad707e16aab2edba0693'
AND (
token = 'bpg//bDOTflI2JDgNq4t0244fxZFOKibHUyFsOoU8Dg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)