UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '48HI2oSvZVWRSnD0F8wxfdsE5weUWBvzdlV6soVkwCw='
WHERE
key_id = 'e3beb4b4ea03787ce7888627d548cd9e3dba0a553275422b2d9585bf82e1c635'
AND (
token = '48HI2oSvZVWRSnD0F8wxfdsE5weUWBvzdlV6soVkwCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)