UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KgmxQ6HE/cE2HDymTD15zb/odWXKl1VQ4/JtNFGX+ww='
WHERE
key_id = 'a1a0c2e0a71187390f2ebaa7e13a43616e68bd907e1a47567a4b41fbd2bf5e77'
AND (
token = 'KgmxQ6HE/cE2HDymTD15zb/odWXKl1VQ4/JtNFGX+ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)