UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '48LDEnt5WL0co5JHiT34KAdph6VevJkqLZSE16K1fKg='
WHERE
key_id = '1db0fa4a5ca77f6c3f885cb36c291440a01f2812920a1f4a145f87dec39bac5c'
AND (
token = '48LDEnt5WL0co5JHiT34KAdph6VevJkqLZSE16K1fKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)