UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pn3GFT3BqndRS8uAEU2uTlwZYW6KvzKIBgICnzVfwYo='
WHERE
key_id = 'df66329869589e440aa03a90be110b29778250f9699b2eeecc23624f46f113e0'
AND (
token = 'pn3GFT3BqndRS8uAEU2uTlwZYW6KvzKIBgICnzVfwYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)