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