UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPUc7Lh2yod2iToYSPJVCk9XhpU4MpvyqRsA7Le1SQU='
WHERE
key_id = '9171f55ab8d1b0cb3f9cdae84321d794bf57eb43934de29b6fcb3223d893925e'
AND (
token = 'tPUc7Lh2yod2iToYSPJVCk9XhpU4MpvyqRsA7Le1SQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)