UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HWeFPjwDLaF/AIYRGKk+KPcomG/bZRathjpa72fyGig='
WHERE
key_id = '4de7025df556e9ba7296fef6b6762897ee2a53591d17b599e38fa441cb194f1f'
AND (
token = 'HWeFPjwDLaF/AIYRGKk+KPcomG/bZRathjpa72fyGig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)