UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u6zvczJA0Aed/8EDgHhZx9LFu0o93ACsJczGRzLQkQg='
WHERE
key_id = 'bdcd3494e20c1305913d6a2b07c05b8dd90365891155e1cdae064ffd62a687a5'
AND (
token = 'u6zvczJA0Aed/8EDgHhZx9LFu0o93ACsJczGRzLQkQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)