UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nI/qCpyiWNb2kDeE06aW+Z7/7SnSgKHjvFPmE+KZP3Q='
WHERE
key_id = '9be6fba8ae34422dfd71bcf4f04c2e3f20d8159db3beb5ce77c6373a7888d39a'
AND (
token = 'nI/qCpyiWNb2kDeE06aW+Z7/7SnSgKHjvFPmE+KZP3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)