UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ETiI8lT+qNtdICXYkkO89qKfa2ozVwauwT6KAlaE6CA='
WHERE
key_id = 'b66fe16f96d9c3282e24fc05f0d7979853f180eac8b99f61e23a44e6ca4c8d02'
AND (
token = 'ETiI8lT+qNtdICXYkkO89qKfa2ozVwauwT6KAlaE6CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)