UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hoZRtXniqVXrQKanHa4krf7J2vpCQEWE3FcjBjos3O4='
WHERE
key_id = '859bd4f0fe5d37b2ce669eb64de0a241514c2570f66760712e78fc1c744c934f'
AND (
token = 'hoZRtXniqVXrQKanHa4krf7J2vpCQEWE3FcjBjos3O4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)