UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNc1201u36J7CqeYnkokcwxxhQvtkgXU3f4AIXFNkhI='
WHERE
key_id = '9525be9354a16cb1e9b0ddf018a5db4fe4a13ef02926adc1b2e1a87072cd08b8'
AND (
token = 'KNc1201u36J7CqeYnkokcwxxhQvtkgXU3f4AIXFNkhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)