UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSQUvZrf5tN7gHUpkZYsZ6uttLaHfV8fIKgUP5AdLLY='
WHERE
key_id = 'aefccc529fa0db6c1f3d774fdb8a2af5d5dea6187e930d7b58b0b7fd30c243e5'
AND (
token = 'pSQUvZrf5tN7gHUpkZYsZ6uttLaHfV8fIKgUP5AdLLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)