UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bd3q3Y7tlxOLUnMLeCI38zXIJrErW/xB/KpHeR0McdA='
WHERE
key_id = 'f5a77943a7c8c3f4c1e5bd93d84916a1b2f64dad4ac7a27b102164da740084c0'
AND (
token = 'bd3q3Y7tlxOLUnMLeCI38zXIJrErW/xB/KpHeR0McdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)